Parameter Object
A Parameter object represents a value supplied to a query. The parameter is associated with a QueryDef object created from a parameter query.
![](/file/23489/Chip-Cover-CD-2007-04d.zip/04d/Hity z okladki/Plus Firma/AccessRT/OSP1.CAB/DAO360.CHM/htm/objquery.gif)
![](/file/23489/Chip-Cover-CD-2007-04d.zip/04d/Hity z okladki/Plus Firma/AccessRT/OSP1.CAB/DAO360.CHM/htm/parchild.gif)
![](/file/23489/Chip-Cover-CD-2007-04d.zip/04d/Hity z okladki/Plus Firma/AccessRT/OSP1.CAB/DAO360.CHM/htm/colparam.gif)
![](/file/23489/Chip-Cover-CD-2007-04d.zip/04d/Hity z okladki/Plus Firma/AccessRT/OSP1.CAB/DAO360.CHM/htm/space.gif)
![](/file/23489/Chip-Cover-CD-2007-04d.zip/04d/Hity z okladki/Plus Firma/AccessRT/OSP1.CAB/DAO360.CHM/htm/parchild.gif)
![](/file/23489/Chip-Cover-CD-2007-04d.zip/04d/Hity z okladki/Plus Firma/AccessRT/OSP1.CAB/DAO360.CHM/htm/objparam.gif)
Remarks
Parameter objects allow you to change the arguments in a frequently run QueryDef object without having to recompile the query.
Using the properties of a Parameter object, you can set a query parameter that can be changed before the query is run. You can:
-
Use the Name property to return the name of a parameter.
-
Use the Value property to set or return the parameter values to be used in the query.
-
Use the Type property to return the data type of the Parameter object.
-
Use the Direction property to set or return whether the parameter is an input parameter, an output parameter, or both.
In an ODBCDirect workspace, you can also:
-
Change the setting of the Type property. Doing so will also clear the Value property.
-
Use the Direction property to set or return whether the parameter is an input parameter, an output parameter, or both.